<?php
// Get JobID
$id = $_GET['id'];
// Security
if( !is_numeric( $id ) )
{
        die( '<div class="message error">
      <h3>Error</h3>
	  <p>There are no jobs listed in our database with the JobID you provided, please contact an administrator if this issue continues to occur.</p></div>' );     
}
// Query Database
$query = @mysql_query( "SELECT `JobID`, `JobTitle`,  `Employer`,  `Description`,  `ContactNumber`,  `ContactEmail`, `Wage`, `Hours`, `Timestamp` FROM `jobs` WHERE `JobID` = '{$id}' ORDER BY `JobID` DESC LIMIT 1;" ) or die( 'Query Error: ' . mysql_error()); 
// Check if database returns a problem or not
$row = mysql_fetch_object( $query );
?>
<h1 class="red"><?php echo $row->JobTitle; ?></h1>
<p><strong>Job Submitted:</strong> <?php echo $row->Timestamp; ?><br />
  <strong>Employer:</strong> <?php echo $row->Employer; ?><br />
  <strong>Contact Number:</strong> <?php echo $row->ContactNumber; ?><br />
  <strong>Contact Email:</strong> <?php echo $row->ContactEmail; ?><br />
  <strong>Wage:</strong> <?php echo $row->Wage; ?><br />
  <strong>Hours:</strong> <?php echo $row->Hours; ?><br />
  <strong>Job Description</strong><br />
<?php echo $row->Description; ?></p>
